<?php
require_once '../php/functions_offfice.php';
require_once '../php/database.php';
 
// start session

session_start();

if (!isset($_SESSION['office'])) {
    die ("ERROR: Unauthorized access!");
}

else {
	if(isset($_GET['approve'])){

	$data = $_SESSION['office']->get_requests_office(0);
	$t=array_keys($_POST);
	$_SESSION['office']->request_approval((int)($data[$t[0]-1]['req_id']),1);
	}
	$data = $_SESSION['office']->get_requests_office(0);

	function displayRequest($data){
			if($data!=NULL){
			$i=0;
			echo " <form id=\"mainform\" action=\"?approve\" method=\"post\">
				<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" id=\"product-table\">
				<tr>
					<!--th class=\"table-header-check\"><a id=\"toggle-all\" ></a> </th-->
					<th class=\"table-header-repeat line-left minwidth-1\"><a href=\"\">Name</a>	</th>
					<th class=\"table-header-repeat line-left minwidth-1\"><a href=\"\">Balance(Rs)</a>	</th>
					<th class=\"table-header-repeat line-left minwidth-1\"><a href=\"\">Request ID</a>	</th>
					<th class=\"table-header-repeat line-left minwidth-1\"><a href=\"\">Date of Request</a>	</th>
					<th class=\"table-header-repeat line-left minwidth-1\"><a href=\"\">Item</a></th>
					<th class=\"table-header-repeat line-left\"><a href=\"\">Amount(Rs)</a></th>
					<th class=\"table-header-repeat line-left\"><a href=\"\">Category</a></th>
					
					<th class=\"table-header-repeat line-left\"><a href=\"\">Priority</a></th>
					<th class=\"table-header-repeat line-left\"><a href=\"\">Advisor</a></th>
					<th class=\"table-header-repeat line-left\"><a href=\"\">Action</a></th>
					
					
				</tr>
				";
			$j=1;
			foreach($data as $request){
				echo ($i%2==1)?"<tr class=\"alternate-row\">":"<tr>";
				echo "<td>".$request['name']."</td><td>".$request['balance']."</td><td>".$request['req_id']."</td><td>".$request['time_stamp']."</td><td>".$request['item_name']."</td><td>".$request['item_cost']."</td><td>".$request['category']."</td><td>".$request['priority']."</td><td>".$request['advisor']."</td><td><input type=\"submit\" class=\"button\" name=\"".$j."\" value=\"Clear and notify Phd\" /></td></tr>";
				$i++;	
				$j++;
			}
			echo "</table>
				<!--  end product-table................................... --> 
				</form>";
			}
			else echo "<h2>You have no pending request.</h2>";
		
	}	
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>GrantED</title>
<link rel="stylesheet" href="../css/screen.css" type="text/css" media="screen" title="default" />
<!--[if IE]>
<link rel="stylesheet" media="all" type="text/css" href="css/pro_dropline_ie.css" />
<![endif]-->

<!--  jquery core -->
<script src="js/jquery/jquery-1.4.1.min.js" type="text/javascript"></script>

<!--  checkbox styling script -->
<script src="js/jquery/ui.core.js" type="text/javascript"></script>
<script src="js/jquery/ui.checkbox.js" type="text/javascript"></script>
<script src="js/jquery/jquery.bind.js" type="text/javascript"></script>
<script type="text/javascript">
$(function(){
	$('input').checkBox();
	$('#toggle-all').click(function(){
 	$('#toggle-all').toggleClass('toggle-checked');
	$('#mainform input[type=checkbox]').checkBox('toggle');
	return false;
	});
});
</script>

<![if !IE 7]>

<!--  styled select box script version 1 -->
<script src="js/jquery/jquery.selectbox-0.5.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
	$('.styledselect').selectbox({ inputClass: "selectbox_styled" });
});
</script>

<![endif]>

<!--  styled select box script version 2 -->
<script src="js/jquery/jquery.selectbox-0.5_style_2.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
	$('.styledselect_form_1').selectbox({ inputClass: "styledselect_form_1" });
	$('.styledselect_form_2').selectbox({ inputClass: "styledselect_form_2" });
});
</script>

<!--  styled select box script version 3 -->
<script src="js/jquery/jquery.selectbox-0.5_style_2.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
	$('.styledselect_pages').selectbox({ inputClass: "styledselect_pages" });
});
</script>

<!--  styled file upload script -->
<script src="js/jquery/jquery.filestyle.js" type="text/javascript"></script>
<script type="text/javascript" charset="utf-8">
  $(function() {
      $("input.file_1").filestyle({ 
          image: "../images/forms/choose-file.gif",
          imageheight : 21,
          imagewidth : 78,
          width : 310
      });
  });
</script>

<!-- Custom jquery scripts -->
<script src="js/jquery/custom_jquery.js" type="text/javascript"></script>

<!-- Tooltips -->
<script src="js/jquery/jquery.tooltip.js" type="text/javascript"></script>
<script src="js/jquery/jquery.dimensions.js" type="text/javascript"></script>
<script type="text/javascript">
$(function() {
	$('a.info-tooltip ').tooltip({
		track: true,
		delay: 0,
		fixPNG: true, 
		showURL: false,
		showBody: " - ",
		top: -35,
		left: 5
	});
});
</script>

<!--  date picker script -->
<link rel="stylesheet" href="css/datePicker.css" type="text/css" />
<script src="js/jquery/date.js" type="text/javascript"></script>
<script src="js/jquery/jquery.datePicker.js" type="text/javascript"></script>
<script type="text/javascript" charset="utf-8">
        $(function()
{

// initialise the "Select date" link
$('#date-pick')
	.datePicker(
		// associate the link with a date picker
		{
			createButton:false,
			startDate:'01/01/2005',
			endDate:'31/12/2020'
		}
	).bind(
		// when the link is clicked display the date picker
		'click',
		function()
		{
			updateSelects($(this).dpGetSelected()[0]);
			$(this).dpDisplay();
			return false;
		}
	).bind(
		// when a date is selected update the SELECTs
		'dateSelected',
		function(e, selectedDate, $td, state)
		{
			updateSelects(selectedDate);
		}
	).bind(
		'dpClosed',
		function(e, selected)
		{
			updateSelects(selected[0]);
		}
	);
	
var updateSelects = function (selectedDate)
{
	var selectedDate = new Date(selectedDate);
	$('#d option[value=' + selectedDate.getDate() + ']').attr('selected', 'selected');
	$('#m option[value=' + (selectedDate.getMonth()+1) + ']').attr('selected', 'selected');
	$('#y option[value=' + (selectedDate.getFullYear()) + ']').attr('selected', 'selected');
}
// listen for when the selects are changed and update the picker
$('#d, #m, #y')
	.bind(
		'change',
		function()
		{
			var d = new Date(
						$('#y').val(),
						$('#m').val()-1,
						$('#d').val()
					);
			$('#date-pick').dpSetSelected(d.asString());
		}
	);

// default the position of the selects to today
var today = new Date();
updateSelects(today.getTime());

// and update the datePicker to reflect it...
$('#d').trigger('change');
});
</script>

<!-- MUST BE THE LAST SCRIPT IN <HEAD></HEAD></HEAD> png fix -->
<script src="js/jquery/jquery.pngFix.pack.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function(){
$(document).pngFix( );
});
</script>
</head>
<body>
<!-- Start: page-top-outer -->
<div id="page-top-outer"> 
  
  <!-- Start: page-top -->
  <div id="page-top"> 
    
    <!-- start logo -->
    <div id="logo"> <a href=""><img src="../images/shared/granted.png" width="300" height="50" alt="" /></a> </div>
    <!-- end logo --> 
    
    <!--  start top-search -->
    <div id="top-search"> <img src="../images/shared/IIITD_white__50.png	" widht="85" height="50" alt="" /> 
      <!--table border="0" cellpadding="0" cellspacing="0">
		<tr>
		<td><input type="text" value="Search" onblur="if (this.value=='') { this.value='Search'; }" onfocus="if (this.value=='Search') { this.value=''; }" class="top-search-inp" /></td>
		<td>
		<select  class="styledselect">
			<option value=""> All</option>
			<option value=""> Products</option>
			<option value=""> Categories</option>
			<option value="">Clients</option>
			<option value="">News</option>
		</select> 
		</td>
		<td>
		<input type="image" src="../images/shared/top_search_btn.gif"  />
		</td>
		</tr>
		</table--> 
    </div>
    <!--  end top-search -->
    <div class="clear"></div>
  </div>
  <!-- End: page-top --> 
  
</div>
<!-- End: page-top-outer -->

<div class="clear">&nbsp;</div>

<!--  start nav-outer-repeat................................................................................................. START -->
<div class="nav-outer-repeat"> 
  <!--  start nav-outer -->
  <div class="nav-outer"> 
    
    <!-- start nav-right -->
    <div id="nav-right"> 
      
      <!--div class="nav-divider">&nbsp;</div>
			<div class="showhide-account"><img src="../images/shared/nav/nav_myaccount.gif" width="93" height="14" alt="" /></div-->
      <div class="nav-divider">&nbsp;</div>
      <a href="logout.php" id="logout"><img src="../images/shared/nav/nav_logout.gif" width="64" height="14" alt="" /></a>
      <div class="clear">&nbsp;</div>
      
      <!--  start account-content >	
			<div class="account-content">
			<div class="account-drop-inner">
				<a href="" id="acc-settings">Settings</a>
				<div class="clear">&nbsp;</div>
				<div class="acc-line">&nbsp;</div>
				<a href="" id="acc-details">Personal details </a>
				<div class="clear">&nbsp;</div>
				<div class="acc-line">&nbsp;</div>
				<a href="" id="acc-project">Project details</a>
				<div class="clear">&nbsp;</div>
				<div class="acc-line">&nbsp;</div>
				<a href="" id="acc-inbox">Inbox</a>
				<div class="clear">&nbsp;</div>
				<div class="acc-line">&nbsp;</div>
				<a href="" id="acc-stats">Statistics</a> 
			</div>
			</div>
			<!--  end account-content --> 
      
    </div>
    <!-- end nav-right --> 
    
    <!--  start nav -->
    <div class="nav">
      <div class="table">
        <ul class="current">
          <li><a href="home.php"><b>Requests</b><!--[if IE 7]><!--></a><!--<![endif]--> 
            <!--[if lte IE 6]><table><tr><td><![endif]--> 
            
            <!--[if lte IE 6]></td></tr></table></a><![endif]--> 
          </li>
        </ul>
        <div class="nav-divider">&nbsp;</div>
        <ul class="select">
          <li><a href="archive.php"><b>Archives</b><!--[if IE 7]><!--></a><!--<![endif]--> 
            <!--[if lte IE 6]><table><tr><td><![endif]--> 
            <!--div class="select_sub">
			<ul class="sub">
				<li><a href="#nogo">Categories Details 1</a></li>
				<li><a href="#nogo">Categories Details 2</a></li>
				<li><a href="#nogo">Categories Details 3</a></li>
			</ul>
		</div>
		<!--[if lte IE 6]></td></tr></table></a><![endif]--> 
          </li>
        </ul>
        <div class="nav-divider">&nbsp;</div>
        <ul class="select">
        	<li>
        		<a href="new_user.php"><b>New User Requests</b></a>
        	</li>
        </ul>
        <div class="nav-divider">&nbsp;</div>
        
        <!--ul class="select"><li><a href="#nogo"><b>News</b><!--[if IE 7]><!--></a><!--<![endif]--> 
        <!--[if lte IE 6]><table><tr><td><![endif]--> 
        <!--div class="select_sub">
			<ul class="sub">
				<li><a href="#nogo">News details 1</a></li>
				<li><a href="#nogo">News details 2</a></li>
				<li><a href="#nogo">News details 3</a></li>
			</ul>
		</div>
		<!--[if lte IE 6]></td></tr></table></a><![endif]--> 
        <!-- /li>
		</ul -->
        
        <div class="clear"></div>
      </div>
      <div class="clear"></div>
    </div>
    <!--  start nav --> 
    
  </div>
  <div class="clear"></div>
  <!--  start nav-outer --> 
</div>
<!--  start nav-outer-repeat................................................... END -->

<div class="clear"></div>

<!-- start content-outer ........................................................................................................................START -->
<div id="content-outer"> 
  <!-- start content -->
  <div id="content"> 
    
    <!--  start page-heading -->
    <div id="page-heading">
      <h1>Pending Requests</h1>
    </div>
    <!-- end page-heading -->
    
    <table border="0" width="100%" cellpadding="0" cellspacing="0" id="content-table">
      <tr>
        <th rowspan="3" class="sized"><img src="../images/shared/side_shadowleft.jpg" width="20" height="300" alt="" /></th>
        <th class="topleft"></th>
        <td id="tbl-border-top">&nbsp;</td>
        <th class="topright"></th>
        <th rowspan="3" class="sized"><img src="../images/shared/side_shadowright.jpg" width="20" height="300" alt="" /></th>
      </tr>
      <tr>
        <td id="tbl-border-left"></td>
        <td><!--  start content-table-inner ...................................................................... START -->
          
          <div id="content-table-inner"> 
            
            <!--  start table-content  -->
            <div id="table-content"> 
              
              <!--  start message-yellow --> 
              <!--div id="message-yellow">
				<table border="0" width="100%" cellpadding="0" cellspacing="0">
				<tr>
					<td class="yellow-left">You have a new message. <a href="">Go to Inbox.</a></td>
					<td class="yellow-right"><a class="close-yellow"><img src="../images/table/icon_close_yellow.gif"   alt="" /></a></td>
				</tr>
				</table>
				</div>
				<!--  end message-yellow --> 
              
              <!--  start message-red --> 
              <!--div id="message-red">
				<table border="0" width="100%" cellpadding="0" cellspacing="0">
				<tr>
					<td class="red-left">Error. <a href="">Please try again.</a></td>
					<td class="red-right"><a class="close-red"><img src="../images/table/icon_close_red.gif"   alt="" /></a></td>
				</tr>
				</table>
				</div>
				<!--  end message-red --> 
              
              <!--  start message-blue --> 
              <!--div id="message-blue">
				<table border="0" width="100%" cellpadding="0" cellspacing="0">
				<tr>
					<td class="blue-left">Welcome back. <a href="">View my account.</a> </td>
					<td class="blue-right"><a class="close-blue"><img src="../images/table/icon_close_blue.gif"   alt="" /></a></td>
				</tr>
				</table>
				</div>
				<!--  end message-blue --> 
              
              <!--  start message-green --> 
              <!--div id="message-green">
				<table border="0" width="100%" cellpadding="0" cellspacing="0">
				<tr>
					<td class="green-left">Product added sucessfully. <a href="">Add new one.</a></td>
					<td class="green-right"><a class="close-green"><img src="../images/table/icon_close_green.gif"   alt="" /></a></td>
				</tr>
				</table>
				</div>
				<!--  end message-green --> 
              
              <!--  start product-table ..................................................................................... -->
              <?php
					displayRequest($data);
				?>
              
              <!--	<tr>
					<td>Dipto Sarkar</td>
					<td>2000</td>
					<td>12345</td>
					<td><a href="">20/09/2012</a></td>
					<td>TextBook</td>
					<td>750</td>
					<td>Books and accessories</td>
					<td>High</td>
					<td><a href="">Ashish Sureka</a></td>
					<td><input type="submit" class="button" value="Clear and notify Phd"/></td>
				</tr>
				<tr class="alternate-row">
					<td>Monika Gupta</td>
					<td>8000</td>
					<td>12346</td>
					<td><a href="">18/09/2012</a></td>
					<td>TextBook</td>
					<td>550</td>
					<td>Books and accessories</td>
					<td>Medium</td>
					<td><a href="">Amarjeet Singh</a></td>
					<td><input type="submit" class="button" value="Clear and notify Phd"/></td>
				</tr>
				<tr>
					<td>Denzil correa</td>
					<td>6000</td>
					<td>12347</td>
					<td><a href="">15/09/2012</a></td>
					<td>Cell Phone</td>
					<td>6000</td>
					<td>Hardware</td>
					<td>High</td>
					<td><a href="">Ashish Sureka</a></td>
					<td><input type="submit" class="button" value="Clear and notify Phd"/></td>
				</tr>
				<tr class="alternate-row">
					<td>Kuldeep Yadav</td>
					<td>5000</td>
					<td>12348</td>
					<td><a href="">18/09/2012</a></td>
					<td>TextBook</td>
					<td>750</td>
					<td>Books and accessories</td>
					<td>Medium</td>
					<td><a href="">Amarjeet Singh</a></td>
					<td><input type="submit" class="button" value="Clear and notify Phd"/></td>
				</tr>
				</tr>
				<tr>
					<td>Anush Sankaran</td>
					<td>4500</td>
					<td>12349</td>
					<td><a href="">18/09/2012</a></td>
					<td>TextBook</td>
					<td>750</td>
					<td>Books and accessories</td>
					<td>Medium</td>
					<td><a href="">Amarjeet Singh</a></td>
					<td><input type="submit" class="button" value="Clear and notify Phd"/></td>
				</tr>
				<tr class="alternate-row">
					<td>Denzil correa</td>
					<td>6500</td>
					<td>12365</td>
					<td><a href="">20/09/2012</a></td>
					<td>Cell Phone</td>
					<td>5000</td>
					<td>Hardware</td>
					<td>High</td>
					<td><a href="">Ashish Sureka</a></td>
					<td><input type="submit" class="button" value="Clear and notify Phd"/></td>
				</tr>
				<tr>
					<td>Kuldeep Yadav</td>
					<td>7000</td>
					<td>12351</td>
					<td><a href="">18/09/2012</a></td>
					<td>TextBook</td>
					<td>750</td>
					<td>Books and accessories</td>
					<td>Medium</td>
					<td><a href="">Amarjeet Singh</a></td>
					<td><input type="submit" class="button" value="Clear and notify Phd"/></td>
				</tr>
				</tr>
				</table>--> 
              <!--  end product-table................................... -->
              </form>
            </div>
            <!--  end content-table  --> 
            
            <!--  start actions-box ............................................... --> 
            
            <!-- end actions-box........... --> 
            
            <!--  start paging..................................................... -->
            <table border="0" cellpadding="0" cellspacing="0" id="paging-table">
              <tr>
                <td><a href="" class="page-far-left"></a> <a href="" class="page-left"></a>
                  <div id="page-info">Page <strong>1</strong> / 15</div>
                  <a href="" class="page-right"></a> <a href="" class="page-far-right"></a></td>
                <td><select  class="styledselect_pages">
                    <option value="">Number of rows</option>
                    <option value="">1</option>
                    <option value="">2</option>
                    <option value="">3</option>
                  </select></td>
              </tr>
            </table>
            <!--  end paging................ -->
            
            <div class="clear"></div>
          </div>
          
          <!--  end content-table-inner ............................................END  --></td>
        <td id="tbl-border-right"></td>
      </tr>
      <tr>
        <th class="sized bottomleft"></th>
        <td id="tbl-border-bottom">&nbsp;</td>
        <th class="sized bottomright"></th>
      </tr>
    </table>
    <div class="clear">&nbsp;</div>
  </div>
  <!--  end content -->
  <div class="clear">&nbsp;</div>
</div>
<!--  end content-outer........................................................END -->

<div class="clear">&nbsp;</div>

<!-- start footer -->
<div id="footer"> 
  <!--  start footer-left -->
  <div id="footer-left"> Granted&copy; <span id="spanYear"></span> <a href="">iiitd.ac.in</a>. All rights reserved.</div>
  <!--  end footer-left -->
  <div class="clear">&nbsp;</div>
</div>
<!-- end footer -->

</body>
</html>
<?php
}
?>
